Problem Note 49225: "Table Service: Function failed... Memory allocation error" occurs when you use SQL code longer than 776 characters within a SAS® DS2 hash object
 |  |  |  |
SAS DS2 enables you to create hash objects using a SQL query. However, there is a 776-character limit on the size of the SQL string that you can use for this functionality. This limit is not specific to the number of variables in the SELECT statement.
To work around this problem, location this string:
h.dataset('{' || sql_string || '}');
Change it to the following:
sqlsub('create view sqlview as ' || sql_string);
h.dataset('sqlview');
In this string, sql_string is the SQL statement that you want to use for your hash data set.
Note: sqlsub is an early version of the sqlexec function. The sqlsub function was renamed sqlexec beginning with SAS® Federation Server 3.1.1. However, sqlsub remains a valid alias for sqlexec in SAS DS2 packages that are executed in the SAS Federation Server.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 |
| Microsoft Windows 8 Enterprise 32-bit | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8 Pro x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8.1 Pro | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 R2 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 R2 Std | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2012 Std | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Windows 7 Enterprise x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Windows 7 Professional x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Linux for x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.3_M1 | 9.4 | 9.3 TS1M2 | 9.4 TS1M0 | ||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2013-10-30 12:18:41 |
| Date Created: | 2013-02-20 14:38:53 |